#######################################################
# Sample Application Configuration File               #
#######################################################

# Postgres95 specific variables; choice of:
# PGHOST, PGOPTIONS, PGPORT, PGTTY, PGDATABASE, PGREALM.
# See the Postgres manual for details, but you will need to set 
# PGDIR the Postgres95 home directory,
# PGHOST the machine on which Postgres is running and PGDATABASE the
# database containing your database files.

PGDIR=/usr/local/postgres95
PGHOST=arthur
PGDATABASE=root

# HTTPD specific stuff; HTTPD-DIR is the httpd home directory,
# CGI-URL is the URL of the cgi-bin directory where
# the generated application scripts will be placed. DOC-URL is a document
# directory where plain HTML files can be placed.

HTTPD-DIR=/usr/local/httpd
CGI-URL=http://arthur/apps
DOC-URL=http://arthur/docs

# Data structure details, TABLE-NAME defines the name of the database class,
# SCREEN-TITLE defines the title on screen, SUMMARY-LIST defines which fields
# are listed on the search summary and FIELDS: is an SQL type definition of 
# the datafile attributes. * denotes primary key and may include several
# attributes. $=attribute FROM class - denotes a foreign key with relationship.
# Terminate each table definition with an END-TABLE clause.

TABLE-NAME=sites
SCREEN-TITLE=Site Details
SUMMARY-LIST=site_code, name
FIELDS:
	site_code char(7) *
	name char(30)
END-TABLE

TABLE-NAME=blocks
SCREEN-TITLE=Block Details
SUMMARY-LIST=site_code, block, description
FIELDS:
	site_code char(7) * $=site_code from sites
	block char(2) *
	description char(45)
	gen_comment char(45)
	area int
	stories int
	volume int
	year_built int
	year_upgraded int
	funct_cap int
	actual_use int
END-TABLE

TABLE-NAME=element
SCREEN-TITLE=Condition Elements
SUMMARY-LIST=element_number, name
FIELDS:
	element_number int *
	name char(25)
END-TABLE 

TABLE-NAME=condition
SCREEN-TITLE=Physical Condition
SUMMARY-LIST=site_code, block, element
FIELDS:
	site_code char(7) * $=site_code FROM sites
	block char(2) * $=block FROM blocks
	element int * $=element_number FROM element
	category char(2)
	life int
	repair int
	upgrade int
END-TABLE 

